Week 8

Milestones

• Wrote query for Sync Telemetry table on HR tab - it gets latest syncs from according to sync_end_time
• Modified queries according to string template
• Added "summary table" in Activities tab - it contains information of all the tables present in ETL database
• Made "users vs median sync time for past week" in HR tab
• Removed tables which are not useful for client from front end
• Adjusted tables according to date filter

Screenshots / Videos

• "Summary Table" in Activities tab on canned analytics page

• "Sync Telemetry" and "Median Sync Time" table in HR tab on canned analytics page

Contributions

• Pull Request

  • https://github.com/avniproject/avni-etl/pull/68

• Issues

  • https://github.com/AvinashRamachandruni/avni-etl/issues/14
  • https://github.com/AvinashRamachandruni/avni-etl/issues/15

Learnings

• Learned about String Template in Java inorder to modify code according to it as it is currently being used in Avni
• Got to know about moment.js library in ReactJS to handle date related queries
• Read about various usecases of Avni and understood what parameters are important for canned analytics